<h1>Database structure</h1>

    <h2>Table dbo.Customer</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>CustomerId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>FirstName</b>  </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>LastName</b>  </td>
                <td>nvarchar</td>
                <td>20</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Company   </td>
                <td>nvarchar</td>
                <td>80</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Address   </td>
                <td>nvarchar</td>
                <td>70</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   City   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   State   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Country   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   PostalCode   </td>
                <td>nvarchar</td>
                <td>10</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Phone   </td>
                <td>nvarchar</td>
                <td>24</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Fax   </td>
                <td>nvarchar</td>
                <td>24</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>Email</b>  </td>
                <td>nvarchar</td>
                <td>60</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   SupportRepId   </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.Employee</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>EmployeeId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>LastName</b>  </td>
                <td>nvarchar</td>
                <td>20</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>FirstName</b>  </td>
                <td>nvarchar</td>
                <td>20</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Title   </td>
                <td>nvarchar</td>
                <td>30</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   ReportsTo   </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   BirthDate   </td>
                <td>datetime</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   HireDate   </td>
                <td>datetime</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Address   </td>
                <td>nvarchar</td>
                <td>70</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   City   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   State   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Country   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   PostalCode   </td>
                <td>nvarchar</td>
                <td>10</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Phone   </td>
                <td>nvarchar</td>
                <td>24</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Fax   </td>
                <td>nvarchar</td>
                <td>24</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Email   </td>
                <td>nvarchar</td>
                <td>60</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.Genre</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>GenreId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>   Name   </td>
                <td>nvarchar</td>
                <td>120</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.Invoice</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>InvoiceId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>CustomerId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>InvoiceDate</b>  </td>
                <td>datetime</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   BillingAddress   </td>
                <td>nvarchar</td>
                <td>70</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   BillingCity   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   BillingState   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   BillingCountry   </td>
                <td>nvarchar</td>
                <td>40</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   BillingPostalCode   </td>
                <td>nvarchar</td>
                <td>10</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>Total</b>  </td>
                <td>numeric</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.InvoiceLine</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>InvoiceLineId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>InvoiceId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>TrackId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>UnitPrice</b>  </td>
                <td>numeric</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>Quantity</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.MediaType</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>MediaTypeId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>   Name   </td>
                <td>nvarchar</td>
                <td>120</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.Playlist</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>PlaylistId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>   Name   </td>
                <td>nvarchar</td>
                <td>120</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.PlaylistTrack</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>PlaylistId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>TrackId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
    </table>
    <h2>Table dbo.Track</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>TrackId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>Name</b>  </td>
                <td>nvarchar</td>
                <td>200</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   AlbumId   </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>MediaTypeId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   GenreId   </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Composer   </td>
                <td>nvarchar</td>
                <td>220</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>Milliseconds</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>   Bytes   </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>UnitPrice</b>  </td>
                <td>numeric</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.AlbumCopy</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>AlbumId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>Title</b>  </td>
                <td>nvarchar</td>
                <td>160</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>ArtistId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.Album</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>AlbumId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>  <b>Title</b>  </td>
                <td>nvarchar</td>
                <td>160</td>
                <td></td>
                <td>                </td>
            </tr>
            <tr>
                <td>  <b>ArtistId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
    <h2>Table dbo.Artist</h2>
    <table>
        <tr>
            <th>Name</th>
            <th>Type</th>
            <th>Length</th>
            <th>Default value</th>
            <th>Keys</th>
        </tr>
            <tr>
                <td>  <b>ArtistId</b>  </td>
                <td>int</td>
                <td>0</td>
                <td></td>
                <td>                        <b>PK</b>
                </td>
            </tr>
            <tr>
                <td>   Name   </td>
                <td>nvarchar</td>
                <td>120</td>
                <td></td>
                <td>                </td>
            </tr>
    </table>
